<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class client_sync extends CI_Controller {

	function __construct()
	{
		parent::__construct();
	}
	function test2()
	{
		//print_r($this->config->config["project_code"]);
		echo $this->udelight->get_code();
	}
	function index()
	{
		$url = "http://www.grandu.co.th/register_sync/index.php/server_sync/index/1000";	
		$result = xml2array($this->load_url($url));
		if($result)
		{
		foreach( $result["root"]["element"] as $row)
		{
			//print_r($this->maping($row));
			$this->save($this->maping($row));
		 
		}
		}
		
	}
	function save($value)
	{
			if($value["card_code"])
			{
				if($this->card_code_check($value["card_code"]))
				{
					$value["tag_code"] = $this->udelight->get_code();
					$this->db->insert("registers",$value);
					echo  $value["firstname"]." ....... Inserted<br/>";
					
				}
				else
				{
					$this->db->where("card_code",$value["card_code"]);
					$this->db->update("registers",$value);
					echo  $value["firstname"]." ....... Updated<br/>";
				}
			}
	}
	function card_code_check($code)
	{
		
			$this->db->where("card_code",$code);
			$cust = $this->db->get("registers")->result_array();
			
			if (count($cust))
			{
				return FALSE;
			}
			else
			{
				return TRUE;
			}
		
	
	}
	function _card_code($row)
	{
		if($row["card_code"]=="")
		{
			return $row["passport"];
			
		}
		else
		{
			return $row["card_code"];
		}
	}
	function check_value($value)
	{
		if(is_array($value))
		{
			return "";
		}
		else 
		{
			return $value;
		}
	}
	function maping($row)
	{
		$values = array();
		
		$values["prefix_name"] = $row["prefix_name"];
		$values["firstname"] = $row["firstname"];
		$values["lastname"] = $row["lastname"];
		$values["birth_day"] = $row["birth_day"];
		$values["birth_month"] = $row["birth_month"];
		$values["birth_year"] = $row["birth_year"];
		
		$values["province_id"] = $this->_get_province_id($row["province_name"]);
		$values["district_id"] = $this->_get_district_id($row["district_name"],$values["province_id"]);
		$values["sub_district_id"] = $this->_get_sub_district_id($row["sub_district_name"],$values["district_id"]);
		$values["zipcode"] =$this->check_value($row["zipcode"]);
		$values["email"] = $this->check_value($row["email"]);
		$values["card_code"] = $this->_card_code($row);
		
		$values["zipcode"] =$row["zipcode"];;
		$values["moo"] =$this->check_value($row["moo"]);
		
		$values["home_street"] =$row["home_street"];
		$values["soi"] =$this->check_value($row["soi"]);
		$values["road"] =$this->check_value($row["road"]);
		
		$values["mobile"] =$row["mobile"];
		$values["zipcode2"] =$row["zipcode2"];
		$values["moo2"] = $this->check_value($row["moo2"]);
		$values["home_street2"] =$row["home_street2"];
		$values["soi2"] = $this->check_value($row["soi2"]);
		
		$values["road2"] =$this->check_value($row["road2"]);
		
		$values["province_id2"] = $this->_get_province_id($row["province_name2"]);;
		$values["district_id2"] = $this->_get_district_id($row["district_name2"],$values["province_id2"]);
		$values["sub_district_id2"] = $this->_get_sub_district_id($row["sub_district_name2"],$values["district_id2"]);
		$values["status"] = $this->_get_status($row["status"]);
		$values["have_child"] = $this->_get_had_child($row["had_child"]);
		$values["child_total"] = $this->check_value($row["child_total"]);
		$values["create_date"] = $row["create_date"];
		$values["at_station"] = "web";
		return $values;
	}
	function _get_had_child($value)
	{
		if($value=="ยังไม่มีบุตร")
		{
			return  0 ;
		}
		else{
			return 1;
		}
	}
	private function load_url($url)
  {
  			$ch = curl_init($url);
			curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($ch, CURLOPT_PROXY, "http://10.40.2.4");
			curl_setopt($ch, CURLOPT_PROXYPORT, 8080);
			curl_setopt ($ch, CURLOPT_PROXYUSERPWD, "tcc\guoutsource:Out@2010"); 
			$result  = curl_exec($ch);
			echo curl_error($ch);
			
				return $result;
			
		curl_close($ch);
  }
	function _get_province_id($value="")
	{
		
		
		
		$this->db->where("province_name",$value) ;
		
		$rows = $this->db->get("province")->result_array();
		if(count($rows))
		{
		return $rows[0]["province_id"];
		}
		else
		{
			return 0;
		}
	}
	function _get_district_id($value,$parent=0)
	{
		
		if($parent ==1)
		{
			$value = "เขต".$value;
		}
		$this->db->where("amphur_name",$value) ;
		$this->db->where("province_id",$parent);
		$rows = $this->db->get("amphur")->result_array();
		if(count($rows))
		{
		return $rows[0]["amphur_id"];
		}
		else
		{
			return 0;
		}
		
	}
	function _get_status($value)
	{
		if("โสด")
		{
			return  0;
		}
		else 
		{
			return 1;
		}
		
	}
	function _get_sub_district_id($value,$parent)
	{
	
		$this->db->where("district_name",$value) ;
		$this->db->where("amphur_id",$parent);
		$rows = $this->db->get("district")->result_array();
		if(count($rows))
		{
			return $rows[0]["district_id"];
		}
	}

}

function xml2array($contents, $get_attributes=1, $priority = 'tag') {
    if(!$contents) return array();

    if(!function_exists('xml_parser_create')) {
        //print "'xml_parser_create()' function not found!";
        return array();
    }

    //Get the XML parser of PHP - PHP must have this module for the parser to work
    $parser = xml_parser_create('');
    xml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, "UTF-8"); # http://minutillo.com/steve/weblog/2004/6/17/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss
    xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
    xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
    xml_parse_into_struct($parser, trim($contents), $xml_values);
    xml_parser_free($parser);

    if(!$xml_values) return;//Hmm...

    //Initializations
    $xml_array = array();
    $parents = array();
    $opened_tags = array();
    $arr = array();

    $current = &$xml_array; //Refference

    //Go through the tags.
    $repeated_tag_index = array();//Multiple tags with same name will be turned into an array
    foreach($xml_values as $data) {
        unset($attributes,$value);//Remove existing values, or there will be trouble

        //This command will extract these variables into the foreach scope
        // tag(string), type(string), level(int), attributes(array).
        extract($data);//We could use the array by itself, but this cooler.

        $result = array();
        $attributes_data = array();
        
        if(isset($value)) {
            if($priority == 'tag') $result = $value;
            else $result['value'] = $value; //Put the value in a assoc array if we are in the 'Attribute' mode
        }

        //Set the attributes too.
        if(isset($attributes) and $get_attributes) {
            foreach($attributes as $attr => $val) {
                if($priority == 'tag') $attributes_data[$attr] = $val;
                else $result['attr'][$attr] = $val; //Set all the attributes in a array called 'attr'
            }
        }

        //See tag status and do the needed.
        if($type == "open") {//The starting of the tag '<tag>'
            $parent[$level-1] = &$current;
            if(!is_array($current) or (!in_array($tag, array_keys($current)))) { //Insert New tag
                $current[$tag] = $result;
                if($attributes_data) $current[$tag. '_attr'] = $attributes_data;
                $repeated_tag_index[$tag.'_'.$level] = 1;

                $current = &$current[$tag];

            } else { //There was another element with the same tag name

                if(isset($current[$tag][0])) {//If there is a 0th element it is already an array
                    $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result;
                    $repeated_tag_index[$tag.'_'.$level]++;
                } else {//This section will make the value an array if multiple tags with the same name appear together
                    $current[$tag] = array($current[$tag],$result);//This will combine the existing item and the new item together to make an array
                    $repeated_tag_index[$tag.'_'.$level] = 2;
                    
                    if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well
                        $current[$tag]['0_attr'] = $current[$tag.'_attr'];
                        unset($current[$tag.'_attr']);
                    }

                }
                $last_item_index = $repeated_tag_index[$tag.'_'.$level]-1;
                $current = &$current[$tag][$last_item_index];
            }

        } elseif($type == "complete") { //Tags that ends in 1 line '<tag />'
            //See if the key is already taken.
            if(!isset($current[$tag])) { //New Key
                $current[$tag] = $result;
                $repeated_tag_index[$tag.'_'.$level] = 1;
                if($priority == 'tag' and $attributes_data) $current[$tag. '_attr'] = $attributes_data;

            } else { //If taken, put all things inside a list(array)
                if(isset($current[$tag][0]) and is_array($current[$tag])) {//If it is already an array...

                    // ...push the new element into that array.
                    $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result;
                    
                    if($priority == 'tag' and $get_attributes and $attributes_data) {
                        $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data;
                    }
                    $repeated_tag_index[$tag.'_'.$level]++;

                } else { //If it is not an array...
                    $current[$tag] = array($current[$tag],$result); //...Make it an array using using the existing value and the new value
                    $repeated_tag_index[$tag.'_'.$level] = 1;
                    if($priority == 'tag' and $get_attributes) {
                        if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well
                            
                            $current[$tag]['0_attr'] = $current[$tag.'_attr'];
                            unset($current[$tag.'_attr']);
                        }
                        
                        if($attributes_data) {
                            $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data;
                        }
                    }
                    $repeated_tag_index[$tag.'_'.$level]++; //0 and 1 index is already taken
                }
            }

        } elseif($type == 'close') { //End of tag '</tag>'
            $current = &$parent[$level-1];
        }
    }
    
    return($xml_array);
}    